﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using RegisterationCommon.Common;

namespace RegisterationSystem.Space_Preschools
{
    public partial class Web : System.Web.UI.Page
    {
        public DataTable dt = new DataTable();
        public DataSet ds = new DataSet();
        public string S = string.Empty;
        public string a = string.Empty;
        protected void Page_Load(object sender, EventArgs e)
        {
            //bind();
            b();
            Session["AccountName"] = Request.QueryString["AccountName"];
            S = Session["myAccountName"].ToString(); ;
        }
        public void b()
        {
            string AccountName = Request.QueryString["AccountName"];

            ds = SqlHelp.ExecuteDataset(SqlHelp.constr, "select  dbo.Students.TrueName as 学生姓名,dbo.Preschools.Name as 幼儿园名称, dbo.SchoolInfo.Name AS 学校名称,Preschools.ID,dbo.Students.Status FROM   dbo.Preschools INNER JOIN dbo.Students ON dbo.Preschools.ID = dbo.Students.PreschoolsID inner join dbo.SchoolInfo on Students.SchID=SchoolInfo.ID where Preschools.AccountName='" + AccountName + "'", CommandType.Text, null); 
        }
    }
}